--
-- Host: localhost    Database: nextcloud
-- ------------------------------------------------------


--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `doc_id` int(10) NOT NULL AUTO_INCREMENT,
  `doc_user` int(10) NOT NULL,
  `doc_name` varchar(255) NOT NULL,
  `doc_folder` int(10) NOT NULL,
  `doc_desc` text NOT NULL,
  `doc_path` varchar(255) NOT NULL,
  `doc_size` varchar(255) NOT NULL,
  `doc_date` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `documents`
--

INSERT INTO `documents` VALUES
(68,6,'fake1',66,'','https://pesuniversitydiag.blob.core.windows.net/file-uploads/chatgpt/fakefile.txt','1048576','2024-03-04 15:43:21'),
(69,6,'fake2',66,'','https://pesuniversitydiag.blob.core.windows.net/file-uploads/chatgpt/fakefile2.txt','2097152','2024-03-04 15:44:21'),
(70,6,'admin',68,'','https://pesuniversitydiag.blob.core.windows.net/file-uploads/upload/fakefile10.txt','10485760','2024-03-04 16:17:34'),
(71,1,'test',70,'','https://pesuniversitydiag.blob.core.windows.net/file-uploads/Srinivas_stmng_valachil_manglore/srini.jpg','937','2024-03-06 11:01:26');

--
-- Table structure for table `folders`
--

CREATE TABLE `folders` (
  `folder_id` int(10) NOT NULL AUTO_INCREMENT,
  `folder_user` int(10) NOT NULL,
  `folder_name` varchar(255) NOT NULL,
  `folder_lock` int(11) DEFAULT 0,
  `folder_date` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`folder_id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `folders`
--

INSERT INTO `folders` VALUES
(66,6,'chatgpt',0,'2024-03-01'),
(70,1,'Srinivas_stmng_valachil_manglore',0,'2024-03-04');

--
-- Table structure for table `friend_requests`
--

CREATE TABLE `friend_requests` (
  `fr_id` int(10) NOT NULL AUTO_INCREMENT,
  `fr_from` int(10) NOT NULL,
  `fr_to` int(10) NOT NULL,
  `fr_status` int(10) NOT NULL,
  `fr_date` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`fr_id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `friend_requests`
--


--
-- Table structure for table `friends`
--

CREATE TABLE `friends` (
  `frd_id` int(10) NOT NULL AUTO_INCREMENT,
  `frd_user` int(10) NOT NULL,
  `frd_friend` int(10) NOT NULL,
  `frd_date` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`frd_id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `friends`
--


--
-- Table structure for table `sharefolder`
--

CREATE TABLE `sharefolder` (
  `sf_id` int(10) NOT NULL AUTO_INCREMENT,
  `sf_user` int(10) NOT NULL,
  `sf_name` varchar(255) NOT NULL,
  `sf_date` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`sf_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sharefolder`
--


--
-- Table structure for table `sharefolder_documents`
--

CREATE TABLE `sharefolder_documents` (
  `sfdoc_id` int(10) NOT NULL AUTO_INCREMENT,
  `sfdoc_user` int(10) NOT NULL,
  `sfdoc_sfid` int(10) NOT NULL,
  `sfdoc_docid` int(10) NOT NULL,
  `sfdoc_date` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`sfdoc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sharefolder_documents`
--


--
-- Table structure for table `sharefolder_members`
--

CREATE TABLE `sharefolder_members` (
  `member_id` int(10) NOT NULL AUTO_INCREMENT,
  `member_sf` int(10) NOT NULL,
  `member_userid` int(10) NOT NULL,
  `member_added` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`member_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sharefolder_members`
--



